package com.dingding.service.user.core.sql;

/**
 * 
 * @ClassName: UserAttachedSQL 
 * @Description: 用户附属属性表操作SQL
 * @author CHEHAUNBO 
 * @date 2016年4月1日 下午3:06:26
 * 
 */
public class UserAttachedSQL {

	/**
	 * 根据用户ID和key获取用户附属属性
	 * @author CHEHUANBO
	 */
	public static final String GET_USER_ATTACHED = "FROM UserAttached utt WHERE utt.loginId = ? AND utt.attachedkey = ?";

	/**
	 * 根据用户ID和key更新用户附属属性
	 * @author CHEHUANBO
	 */
	public static final String UPDATE_USER_ATTACHED = "UPDATE userattached utt SET  utt.attachedkeyValue = ? WHERE utt.loginId = ? AND utt.attachedkey = ?";
	
	/**
	 * 重置用户每日签到状态
	 * @author YHQ
	 */
	public static final String RESET_USER_ATTACHED = "UPDATE userattached utt SET  utt.attachedkeyValue = 1 WHERE utt.attachedkey = 'isAttendActivity'";
	
}
